<?php
/* @var $installer Mage_Core_Model_Resource_Setup */
$installer = $this;
$installer->startSetup();

$installer->run("
    ALTER TABLE {$this->getTable('simplenews/category')} ADD COLUMN `meta_title` varchar(255) NOT NULL default '';
    ALTER TABLE {$this->getTable('simplenews/category')} ADD COLUMN `meta_keywords` varchar(255) NOT NULL default '';
    ALTER TABLE {$this->getTable('simplenews/category')} ADD COLUMN `meta_description` text NOT NULL default '';

    ALTER TABLE {$this->getTable('simplenews/news')} ADD COLUMN `meta_title` varchar(255) NOT NULL default '';
    ALTER TABLE {$this->getTable('simplenews/news')} ADD COLUMN `meta_keywords` varchar(255) NOT NULL default '';
    ALTER TABLE {$this->getTable('simplenews/news')} ADD COLUMN `meta_description` text NOT NULL default '';    
");

$installer->endSetup();